<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-3-30. 16:23:32-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Storage and Storage Pool Capacity']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:1500px"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>SAN Switch Inventory</staticValue></dataSource></textItem></contents><style><CSS value="height:36px;padding-left:10px;font-family:Arial;font-size:24px;color:#333333;background-color:#FBFBFB;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Ports</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton1" refQuery="Summary - Physical">
			<contents><textItem><dataSource><dataItemValue refDataItem="Total Ports"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Used Ports</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton2" refQuery="Summary - Physical">
			<contents><textItem><dataSource><dataItemValue refDataItem="Used Ports"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Free Ports</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton3" refQuery="Summary - Physical">
			<contents><textItem><dataSource><dataItemValue refDataItem="Free Ports"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>% Free</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton4" refQuery="Summary - Physical">
			<contents><textItem><dataSource><dataItemValue refDataItem="% Free"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><percentFormat/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:1.5pt solid #ADB2B5"/></style></tableCell><tableCell><contents/></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Port OK</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton6" refQuery="Summary - Physical">
			<contents><textItem><dataSource><dataItemValue refDataItem="Port OK"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:1.5pt solid #ADB2B5"/></style></tableCell><tableCell><contents/></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Port InActive</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton7" refQuery="Summary - Physical">
			<contents><textItem><dataSource><dataItemValue refDataItem="In-Active"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:1.5pt solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Port Errors</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton5" refQuery="Summary - Physical">
			<contents><textItem><dataSource><dataItemValue refDataItem="Port Error"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-bottom:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top 5 Switches</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Free Ports)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents><v2_combinationChart maxHotspots="10000" orientation="horizontal" refQuery="Top 5 Switches Free Ports" name="Combination Chart1" depth="9">
																																						<v2_combinationTypeTooltips/>
																																						
																																						<v2_commonAxis>
																																							<v2_ordinalAxis>
																																								<v2_axisLabels>
																																									<style>
																																										<defaultStyles>
																																											<defaultStyle refStyle="al"/>
																																										</defaultStyles>
																																									<CSS value="color:#454545"/></style>
																																								</v2_axisLabels>
																																							</v2_ordinalAxis>
																																						<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Switch"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Free Ports"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																																						<v2_topLeftAxis>
																																							<v2_combinationChartTypes>
																																								<v2_bar borderColor="white" setOrdinalWidthScale="80" bevel="none" barShape="box">
																																									<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Free Ports"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/></v2_bar>
																																							</v2_combinationChartTypes>
																																							<v2_axis>
																																								<v2_axisRange>
																																									<v2_automaticRange/>
																																								</v2_axisRange>
																																								<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/></style>
																																		</v2_axisLabels><v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/></v2_axis>
																																						</v2_topLeftAxis>
																																						<style>
																																							<CSS value="width:450px;height:200px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																																						
																																					<v2_legend>
																																							<style>
																																								<defaultStyles>
																																									<defaultStyle refStyle="lg"/>
																																								</defaultStyles>
																																								<CSS value="color:#454545"/></style>
																																							<v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="bottom"/>
																																	</v2_legendPosition></v2_legend></v2_combinationChart>
																														</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Port Utilization Trending</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart7" refQuery="Port Utilization Trending">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="fulldate"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="fulldate"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="yyyy-MM"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_line lineAreaShape="smooth" lineDisplayType="lineAndMarkers"><v2_linePalette markerBorderColor="white" markerBorders="show" markerSize="8px"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#88B2D3"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#FFB2C1"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Used Ports"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line></v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange scale="linear">
																							
																						<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/></v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:450px;height:200px"/></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				<v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style>
																				</v2_legend>
																				<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-left:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Raw Port Status</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents><v2_combinationChart maxHotspots="10000" orientation="horizontal" refQuery="All Port Errors" name="Combination Chart2" depth="9">
																																						<v2_combinationTypeTooltips/>
																																						
																																						<v2_commonAxis>
																																							<v2_ordinalAxis>
																																								<v2_axisLabels>
																																									<style>
																																										<defaultStyles>
																																											<defaultStyle refStyle="al"/>
																																										</defaultStyles>
																																									<CSS value="color:#454545"/></style>
																																								</v2_axisLabels>
																																							</v2_ordinalAxis>
																																						<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Port Status"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Port Count"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																																						<v2_topLeftAxis>
																																							<v2_combinationChartTypes>
																																								<v2_bar borderColor="white" setOrdinalWidthScale="80" bevel="none" barShape="box">
																																									<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Port Count"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																																							</v2_combinationChartTypes>
																																							<v2_axis>
																																								<v2_axisRange>
																																									<v2_automaticRange/>
																																								</v2_axisRange>
																																								<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/></style>
																																		</v2_axisLabels><v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/></v2_axis>
																																						</v2_topLeftAxis>
																																						<style>
																																							<CSS value="width:450px;height:200px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																																						
																																					<v2_legend>
																																							<style>
																																								<defaultStyles>
																																									<defaultStyle refStyle="lg"/>
																																								</defaultStyles>
																																								<CSS value="color:#454545"/></style>
																																							<v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="bottom"/>
																																	</v2_legendPosition></v2_legend></v2_combinationChart>
																														</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:10px;background-color:#F7F7F7;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Switch Inventory</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Physical)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<list horizontalPagination="true" name="List1" rowsPerPage="500" refQuery="Switch Inventory - Physical">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Data Center"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Data Center"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Switch"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Switch"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Vendor"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Vendor"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Model"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Model"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Serial Number"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Serial Number"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Firmware"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Firmware"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Total Ports"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:80px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Total Ports"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Free Ports"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:80px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Free Ports"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Used Ports"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:80px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Used Ports"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="% Free"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:80px;background-color:#9AD7CD"/><dataFormat><percentFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="% Free"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="F-Port Count"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:80px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="F-Port Count"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="E-Port Count"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:80px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="E-Port Count"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="OtherPortCount"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:80px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="OtherPortCount"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Port OK"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:80px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Port OK"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Port Error"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:80px;background-color:#FFB2C1"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Port Error"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="In-Active"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:80px;background-color:#FFE785"/></style><contents><textItem><dataSource><dataItemValue refDataItem="In-Active"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-right:10px;padding-left:10px;padding-top:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Switch Inventory</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(NPV)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<list horizontalPagination="true" name="List2" rowsPerPage="500" refQuery="Switch Inventory - NPV">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Data Center"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Data Center"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Switch"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Switch"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Vendor"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Vendor"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Model"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Model"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Serial Number"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Serial Number"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Firmware"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Firmware"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Total Ports"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:80px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Total Ports"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Free Ports"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:80px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Free Ports"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Used Ports"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:80px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Used Ports"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="% Free"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:80px;background-color:#9AD7CD"/><dataFormat><percentFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="% Free"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="F-Port Count"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:80px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="F-Port Count"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="E-Port Count"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:80px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="E-Port Count"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="OtherPortCount"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:80px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="OtherPortCount"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Port OK"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:80px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Port OK"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Port Error"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:80px;background-color:#FFB2C1"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Port Error"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="In-Active"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:80px;background-color:#FFE785"/></style><contents><textItem><dataSource><dataItemValue refDataItem="In-Active"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding:5px 10px 10px 10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.811Z"/></XMLAttributes><reportName>7.5 SAN Switch Inventory</reportName><classStyles><classStyle name="freezeColumns" label="freezeColumns"/><classStyle name="freezeRows" label="freezeRows"/><classStyle name="freezeCorner" label="freezeCorner"/></classStyles><queries><query name="Switch Inventory - Physical">
			<source>
				
			<sqlQuery name="SQL2" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT
a.DataCenter as 'Data Center',
a.Switch as 'Switch',
a.Vendor as 'Vendor',
a.Model as 'Model',
a.SerialNumber as 'Serial Number',
a.Firmware as 'Firmware',
a.TotalPorts as 'Total Ports',
b.FreePorts as 'Free Ports',
c.UsedPorts as 'Used Ports',
b.FreePorts/a.TotalPorts as '% Free',
a.FPortCount as 'F-Port Count',
a.EPortCount as 'E-Port Count',
a.OtherPortCount as 'OtherPortCount',
a.PortOK as 'Port OK',
a.PortERROR as 'Port Error',
a.PortINACTIVE as 'In-Active'

FROM
(
SELECT
         dwh_inventory.switch.datacenter as 'DataCenter',
         dwh_inventory.switch.name as 'Switch',
         dwh_inventory.switch.manufacturer as 'Vendor',
         dwh_inventory.switch.model as 'Model',
         dwh_inventory.switch.serialnumber as 'SerialNumber',
         dwh_inventory.switch.firmware as 'Firmware',
         
         dwh_inventory.switch.id as switchid,
   	 COUNT(DISTINCT dwh_inventory.switch_port.id) AS 'TotalPorts',
   	 
   	 SUM(IF(dwh_inventory.switch_port.type='F-Port',1,0)) as 'FPortCount',
   	 SUM(IF(dwh_inventory.switch_port.type='E-Port',1,0)) as 'EPortCount',
   	 SUM(IF(dwh_inventory.switch_port.type NOT IN ('F-Port','E-Port'),1,0)) as 'OtherPortCount',
   	 
   	 
   	 SUM(IF(dwh_inventory.switch_port.status='OK',1,0)) as 'PortOK',
   	 SUM(IF(dwh_inventory.switch_port.status='ERROR',1,0)) as 'PortERROR',
   	 SUM(IF(dwh_inventory.switch_port.status='INACTIVE',1,0)) as 'PortINACTIVE'
   	
   	 
   	 
   	 
FROM
	dwh_inventory.switch_port
JOIN	dwh_inventory.switch
ON	dwh_inventory.switch_port.switchId = dwh_inventory.switch.id
AND	dwh_inventory.switch.npv = 0
AND	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.switch_port.id FROM dwh_inventory.switch_port WHERE dwh_inventory.switch_port.gbicType LIKE '%ICL%')
AND	dwh_inventory.switch_port.active = 1
AND	dwh_inventory.switch_port.status &lt;&gt; 'NOT_LICENSED'
AND	dwh_inventory.switch_port.name NOT LIKE '%vfc%'
GROUP BY dwh_inventory.switch.id ) a

JOIN
(

SELECT 

dwh_inventory.switch.id as switchid,
	COUNT(DISTINCT dwh_inventory.switch_port.id) AS 'FreePorts'

FROM	dwh_inventory.switch_port
JOIN	dwh_inventory.switch
ON	dwh_inventory.switch_port.switchId = dwh_inventory.switch.id
AND	dwh_inventory.switch.npv = 0
AND	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.switch_port.id FROM dwh_inventory.switch_port WHERE dwh_inventory.switch_port.gbicType LIKE '%ICL%')
AND	dwh_inventory.switch_port.active = 1
AND	dwh_inventory.switch_port.status &lt;&gt; 'NOT_LICENSED'
AND	dwh_inventory.switch_port.name NOT LIKE '%vfc%'
AND	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.port_connectivity.portId FROM dwh_inventory.port_connectivity)

GROUP BY dwh_inventory.switch.id) b ON b.switchid=a.switchid

JOIN
(

SELECT 	
dwh_inventory.switch.id as switchid,
COUNT(DISTINCT dwh_inventory.switch_port.id) AS 'UsedPorts'

FROM	dwh_inventory.switch_port
JOIN	dwh_inventory.switch
ON	dwh_inventory.switch_port.switchId = dwh_inventory.switch.id
AND	dwh_inventory.switch.npv = 0
AND	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.switch_port.id FROM dwh_inventory.switch_port WHERE dwh_inventory.switch_port.gbicType LIKE '%ICL%')
AND	dwh_inventory.switch_port.active = 1
AND	dwh_inventory.switch_port.status &lt;&gt; 'NOT_LICENSED'
AND	dwh_inventory.switch_port.name NOT LIKE '%vfc%'
AND	dwh_inventory.switch_port.id IN (SELECT dwh_inventory.port_connectivity.portId FROM dwh_inventory.port_connectivity)
GROUP BY dwh_inventory.switch.id

) c ON c.switchid=a.switchid

</sqlText>
		<mdProjectedItems><mdProjectedItem name="Data Center"/><mdProjectedItem name="Switch"/><mdProjectedItem name="Vendor"/><mdProjectedItem name="Model"/><mdProjectedItem name="Serial Number"/><mdProjectedItem name="Firmware"/><mdProjectedItem name="Total Ports"/><mdProjectedItem name="Free Ports"/><mdProjectedItem name="Used Ports"/><mdProjectedItem name="% Free"/><mdProjectedItem name="F-Port Count"/><mdProjectedItem name="E-Port Count"/><mdProjectedItem name="OtherPortCount"/><mdProjectedItem name="Port OK"/><mdProjectedItem name="Port Error"/><mdProjectedItem name="In-Active"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Data Center"><expression>[SQL2].[Data Center]</expression></dataItem><dataItem name="Switch"><expression>[SQL2].[Switch]</expression></dataItem><dataItem name="Vendor"><expression>[SQL2].[Vendor]</expression></dataItem><dataItem name="Model"><expression>[SQL2].[Model]</expression></dataItem><dataItem name="Serial Number"><expression>[SQL2].[Serial Number]</expression></dataItem><dataItem name="Firmware"><expression>[SQL2].[Firmware]</expression></dataItem><dataItem name="Total Ports" aggregate="total"><expression>[SQL2].[Total Ports]</expression></dataItem><dataItem name="Free Ports" aggregate="total"><expression>[SQL2].[Free Ports]</expression></dataItem><dataItem name="Used Ports" aggregate="total"><expression>[SQL2].[Used Ports]</expression></dataItem><dataItem name="% Free"><expression>[SQL2].[% Free]</expression></dataItem><dataItem name="F-Port Count"><expression>[SQL2].[F-Port Count]</expression></dataItem><dataItem name="E-Port Count"><expression>[SQL2].[E-Port Count]</expression></dataItem><dataItem name="OtherPortCount"><expression>[SQL2].[OtherPortCount]</expression></dataItem><dataItem name="Port OK"><expression>[SQL2].[Port OK]</expression></dataItem><dataItem name="Port Error" aggregate="total"><expression>[SQL2].[Port Error]</expression></dataItem><dataItem name="In-Active"><expression>[SQL2].[In-Active]</expression></dataItem></selection>
		</query><query name="Switch Inventory - NPV">
			<source>
				
			<sqlQuery name="SQL4" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT
a.DataCenter as 'Data Center',
a.Switch as 'Switch',
a.Vendor as 'Vendor',
a.Model as 'Model',
a.SerialNumber as 'Serial Number',
a.Firmware as 'Firmware',
a.TotalPorts as 'Total Ports',
b.FreePorts as 'Free Ports',
c.UsedPorts as 'Used Ports',
b.FreePorts/a.TotalPorts as '% Free',
a.FPortCount as 'F-Port Count',
a.EPortCount as 'E-Port Count',
a.OtherPortCount as 'OtherPortCount',
a.PortOK as 'Port OK',
a.PortERROR as 'Port Error',
a.PortINACTIVE as 'In-Active'

FROM
(
SELECT
         dwh_inventory.switch.datacenter as 'DataCenter',
         dwh_inventory.switch.name as 'Switch',
         dwh_inventory.switch.manufacturer as 'Vendor',
         dwh_inventory.switch.model as 'Model',
         dwh_inventory.switch.serialnumber as 'SerialNumber',
         dwh_inventory.switch.firmware as 'Firmware',
         
         dwh_inventory.switch.id as switchid,
   	 COUNT(DISTINCT dwh_inventory.switch_port.id) AS 'TotalPorts',
   	 
   	 SUM(IF(dwh_inventory.switch_port.type='F-Port',1,0)) as 'FPortCount',
   	 SUM(IF(dwh_inventory.switch_port.type='E-Port',1,0)) as 'EPortCount',
   	 SUM(IF(dwh_inventory.switch_port.type NOT IN ('F-Port','E-Port'),1,0)) as 'OtherPortCount',
   	 
   	 
   	 SUM(IF(dwh_inventory.switch_port.status='OK',1,0)) as 'PortOK',
   	 SUM(IF(dwh_inventory.switch_port.status='ERROR',1,0)) as 'PortERROR',
   	 SUM(IF(dwh_inventory.switch_port.status='INACTIVE',1,0)) as 'PortINACTIVE'
   	
   	 
   	 
   	 
FROM
	dwh_inventory.switch_port
JOIN	dwh_inventory.switch
ON	dwh_inventory.switch_port.switchId = dwh_inventory.switch.id
AND	dwh_inventory.switch.npv = 1
AND	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.switch_port.id FROM dwh_inventory.switch_port WHERE dwh_inventory.switch_port.gbicType LIKE '%ICL%')
AND	dwh_inventory.switch_port.active = 1
AND	dwh_inventory.switch_port.status &lt;&gt; 'NOT_LICENSED'
AND	dwh_inventory.switch_port.name NOT LIKE '%vfc%'
GROUP BY dwh_inventory.switch.id ) a

JOIN
(

SELECT 

dwh_inventory.switch.id as switchid,
	COUNT(DISTINCT dwh_inventory.switch_port.id) AS 'FreePorts'

FROM	dwh_inventory.switch_port
JOIN	dwh_inventory.switch
ON	dwh_inventory.switch_port.switchId = dwh_inventory.switch.id
AND	dwh_inventory.switch.npv = 1
AND	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.switch_port.id FROM dwh_inventory.switch_port WHERE dwh_inventory.switch_port.gbicType LIKE '%ICL%')
AND	dwh_inventory.switch_port.active = 1
AND	dwh_inventory.switch_port.status &lt;&gt; 'NOT_LICENSED'
AND	dwh_inventory.switch_port.name NOT LIKE '%vfc%'
AND	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.port_connectivity.portId FROM dwh_inventory.port_connectivity)

GROUP BY dwh_inventory.switch.id) b ON b.switchid=a.switchid

JOIN
(

SELECT 	
dwh_inventory.switch.id as switchid,
COUNT(DISTINCT dwh_inventory.switch_port.id) AS 'UsedPorts'

FROM	dwh_inventory.switch_port
JOIN	dwh_inventory.switch
ON	dwh_inventory.switch_port.switchId = dwh_inventory.switch.id
AND	dwh_inventory.switch.npv = 1
AND	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.switch_port.id FROM dwh_inventory.switch_port WHERE dwh_inventory.switch_port.gbicType LIKE '%ICL%')
AND	dwh_inventory.switch_port.active = 1
AND	dwh_inventory.switch_port.status &lt;&gt; 'NOT_LICENSED'
AND	dwh_inventory.switch_port.name NOT LIKE '%vfc%'
AND	dwh_inventory.switch_port.id IN (SELECT dwh_inventory.port_connectivity.portId FROM dwh_inventory.port_connectivity)
GROUP BY dwh_inventory.switch.id

) c ON c.switchid=a.switchid

</sqlText>
		<mdProjectedItems><mdProjectedItem name="Data Center"/><mdProjectedItem name="Switch"/><mdProjectedItem name="Vendor"/><mdProjectedItem name="Model"/><mdProjectedItem name="Serial Number"/><mdProjectedItem name="Firmware"/><mdProjectedItem name="Total Ports"/><mdProjectedItem name="Free Ports"/><mdProjectedItem name="Used Ports"/><mdProjectedItem name="% Free"/><mdProjectedItem name="F-Port Count"/><mdProjectedItem name="E-Port Count"/><mdProjectedItem name="OtherPortCount"/><mdProjectedItem name="Port OK"/><mdProjectedItem name="Port Error"/><mdProjectedItem name="In-Active"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Data Center"><expression>[SQL4].[Data Center]</expression></dataItem><dataItem name="Switch"><expression>[SQL4].[Switch]</expression></dataItem><dataItem name="Vendor"><expression>[SQL4].[Vendor]</expression></dataItem><dataItem name="Model"><expression>[SQL4].[Model]</expression></dataItem><dataItem name="Serial Number"><expression>[SQL4].[Serial Number]</expression></dataItem><dataItem name="Firmware"><expression>[SQL4].[Firmware]</expression></dataItem><dataItem name="Total Ports"><expression>[SQL4].[Total Ports]</expression></dataItem><dataItem name="Free Ports"><expression>[SQL4].[Free Ports]</expression></dataItem><dataItem name="Used Ports"><expression>[SQL4].[Used Ports]</expression></dataItem><dataItem name="% Free"><expression>[SQL4].[% Free]</expression></dataItem><dataItem name="F-Port Count"><expression>[SQL4].[F-Port Count]</expression></dataItem><dataItem name="E-Port Count"><expression>[SQL4].[E-Port Count]</expression></dataItem><dataItem name="OtherPortCount"><expression>[SQL4].[OtherPortCount]</expression></dataItem><dataItem name="Port OK"><expression>[SQL4].[Port OK]</expression></dataItem><dataItem name="Port Error"><expression>[SQL4].[Port Error]</expression></dataItem><dataItem name="In-Active"><expression>[SQL4].[In-Active]</expression></dataItem></selection>
		</query><query name="Summary - Physical">
			<source>
				
			<sqlQuery name="SQL3" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT
SUM(a.TotalPorts) as 'Total Ports',
SUM(b.FreePorts) as 'Free Ports',
SUM(c.UsedPorts) as 'Used Ports',
SUM(b.FreePorts) / SUM(a.TotalPorts) as '% Free',
SUM(a.FPortCount) as 'F-Port Count',
SUM(a.EPortCount) as 'E-Port Count',
SUM(a.OtherPortCount) as 'OtherPortCount',
SUM(a.PortOK) as 'Port OK',
SUM(a.PortERROR) as 'Port Error',
SUM(a.PortINACTIVE) as 'In-Active'

FROM
(
SELECT
                  
         dwh_inventory.switch.id as switchid,
   	 COUNT(DISTINCT dwh_inventory.switch_port.id) AS 'TotalPorts',
   	 
   	 SUM(IF(dwh_inventory.switch_port.type='F-Port',1,0)) as 'FPortCount',
   	 SUM(IF(dwh_inventory.switch_port.type='E-Port',1,0)) as 'EPortCount',
   	 SUM(IF(dwh_inventory.switch_port.type NOT IN ('F-Port','E-Port'),1,0)) as 'OtherPortCount',
   	 
   	 
   	 SUM(IF(dwh_inventory.switch_port.status='OK',1,0)) as 'PortOK',
   	 SUM(IF(dwh_inventory.switch_port.status='ERROR',1,0)) as 'PortERROR',
   	 SUM(IF(dwh_inventory.switch_port.status='INACTIVE',1,0)) as 'PortINACTIVE'
   	
   	 
   	 
   	 
FROM
	dwh_inventory.switch_port
JOIN	dwh_inventory.switch
ON	dwh_inventory.switch_port.switchId = dwh_inventory.switch.id
AND	dwh_inventory.switch.npv = 0
AND	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.switch_port.id FROM dwh_inventory.switch_port WHERE dwh_inventory.switch_port.gbicType LIKE '%ICL%')
AND	dwh_inventory.switch_port.active = 1
AND	dwh_inventory.switch_port.status &lt;&gt; 'NOT_LICENSED'
AND	dwh_inventory.switch_port.name NOT LIKE '%vfc%'
GROUP BY dwh_inventory.switch.id ) a

JOIN
(

SELECT 

dwh_inventory.switch.id as switchid,
	COUNT(DISTINCT dwh_inventory.switch_port.id) AS 'FreePorts'

FROM	dwh_inventory.switch_port
JOIN	dwh_inventory.switch
ON	dwh_inventory.switch_port.switchId = dwh_inventory.switch.id
AND	dwh_inventory.switch.npv = 0
AND	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.switch_port.id FROM dwh_inventory.switch_port WHERE dwh_inventory.switch_port.gbicType LIKE '%ICL%')
AND	dwh_inventory.switch_port.active = 1
AND	dwh_inventory.switch_port.status &lt;&gt; 'NOT_LICENSED'
AND	dwh_inventory.switch_port.name NOT LIKE '%vfc%'
AND	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.port_connectivity.portId FROM dwh_inventory.port_connectivity)

GROUP BY dwh_inventory.switch.id) b ON b.switchid=a.switchid

JOIN
(

SELECT 	
dwh_inventory.switch.id as switchid,
COUNT(DISTINCT dwh_inventory.switch_port.id) AS 'UsedPorts'

FROM	dwh_inventory.switch_port
JOIN	dwh_inventory.switch
ON	dwh_inventory.switch_port.switchId = dwh_inventory.switch.id
AND	dwh_inventory.switch.npv = 0
AND	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.switch_port.id FROM dwh_inventory.switch_port WHERE dwh_inventory.switch_port.gbicType LIKE '%ICL%')
AND	dwh_inventory.switch_port.active = 1
AND	dwh_inventory.switch_port.status &lt;&gt; 'NOT_LICENSED'
AND	dwh_inventory.switch_port.name NOT LIKE '%vfc%'
AND	dwh_inventory.switch_port.id IN (SELECT dwh_inventory.port_connectivity.portId FROM dwh_inventory.port_connectivity)
GROUP BY dwh_inventory.switch.id

) c ON c.switchid=a.switchid

</sqlText>
		<mdProjectedItems><mdProjectedItem name="Total Ports"/><mdProjectedItem name="Free Ports"/><mdProjectedItem name="Used Ports"/><mdProjectedItem name="% Free"/><mdProjectedItem name="F-Port Count"/><mdProjectedItem name="E-Port Count"/><mdProjectedItem name="OtherPortCount"/><mdProjectedItem name="Port OK"/><mdProjectedItem name="Port Error"/><mdProjectedItem name="In-Active"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Total Ports"><expression>[SQL3].[Total Ports]</expression></dataItem><dataItem name="Free Ports"><expression>[SQL3].[Free Ports]</expression></dataItem><dataItem name="Used Ports"><expression>[SQL3].[Used Ports]</expression></dataItem><dataItem name="% Free"><expression>[SQL3].[% Free]</expression></dataItem><dataItem name="F-Port Count"><expression>[SQL3].[F-Port Count]</expression></dataItem><dataItem name="E-Port Count"><expression>[SQL3].[E-Port Count]</expression></dataItem><dataItem name="OtherPortCount"><expression>[SQL3].[OtherPortCount]</expression></dataItem><dataItem name="Port OK"><expression>[SQL3].[Port OK]</expression></dataItem><dataItem name="Port Error"><expression>[SQL3].[Port Error]</expression></dataItem><dataItem name="In-Active"><expression>[SQL3].[In-Active]</expression></dataItem></selection>
		</query><query name="Top 5 Switches Free Ports">
			<source>
				
			<sqlQuery name="SQL5" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT
a.DataCenter as 'Data Center',
a.Switch as 'Switch',
a.Vendor as 'Vendor',
a.Model as 'Model',
a.SerialNumber as 'Serial Number',
a.Firmware as 'Firmware',
a.TotalPorts as 'Total Ports',
b.FreePorts as 'Free Ports',
c.UsedPorts as 'Used Ports',
b.FreePorts/a.TotalPorts as '% Free',
a.FPortCount as 'F-Port Count',
a.EPortCount as 'E-Port Count',
a.OtherPortCount as 'OtherPortCount',
a.PortOK as 'Port OK',
a.PortERROR as 'Port Error',
a.PortINACTIVE as 'In-Active'

FROM
(
SELECT
         dwh_inventory.switch.datacenter as 'DataCenter',
         dwh_inventory.switch.name as 'Switch',
         dwh_inventory.switch.manufacturer as 'Vendor',
         dwh_inventory.switch.model as 'Model',
         dwh_inventory.switch.serialnumber as 'SerialNumber',
         dwh_inventory.switch.firmware as 'Firmware',
         
         dwh_inventory.switch.id as switchid,
   	 COUNT(DISTINCT dwh_inventory.switch_port.id) AS 'TotalPorts',
   	 
   	 SUM(IF(dwh_inventory.switch_port.type='F-Port',1,0)) as 'FPortCount',
   	 SUM(IF(dwh_inventory.switch_port.type='E-Port',1,0)) as 'EPortCount',
   	 SUM(IF(dwh_inventory.switch_port.type NOT IN ('F-Port','E-Port'),1,0)) as 'OtherPortCount',
   	 
   	 
   	 SUM(IF(dwh_inventory.switch_port.status='OK',1,0)) as 'PortOK',
   	 SUM(IF(dwh_inventory.switch_port.status='ERROR',1,0)) as 'PortERROR',
   	 SUM(IF(dwh_inventory.switch_port.status='INACTIVE',1,0)) as 'PortINACTIVE'
   	
   	 
   	 
   	 
FROM
	dwh_inventory.switch_port
JOIN	dwh_inventory.switch
ON	dwh_inventory.switch_port.switchId = dwh_inventory.switch.id
AND	dwh_inventory.switch.npv = 0
AND	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.switch_port.id FROM dwh_inventory.switch_port WHERE dwh_inventory.switch_port.gbicType LIKE '%ICL%')
AND	dwh_inventory.switch_port.active = 1
AND	dwh_inventory.switch_port.status &lt;&gt; 'NOT_LICENSED'
AND	dwh_inventory.switch_port.name NOT LIKE '%vfc%'
GROUP BY dwh_inventory.switch.id ) a

JOIN
(

SELECT 

dwh_inventory.switch.id as switchid,
	COUNT(DISTINCT dwh_inventory.switch_port.id) AS 'FreePorts'

FROM	dwh_inventory.switch_port
JOIN	dwh_inventory.switch
ON	dwh_inventory.switch_port.switchId = dwh_inventory.switch.id
AND	dwh_inventory.switch.npv = 0
AND	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.switch_port.id FROM dwh_inventory.switch_port WHERE dwh_inventory.switch_port.gbicType LIKE '%ICL%')
AND	dwh_inventory.switch_port.active = 1
AND	dwh_inventory.switch_port.status &lt;&gt; 'NOT_LICENSED'
AND	dwh_inventory.switch_port.name NOT LIKE '%vfc%'
AND	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.port_connectivity.portId FROM dwh_inventory.port_connectivity)

GROUP BY dwh_inventory.switch.id) b ON b.switchid=a.switchid

JOIN
(

SELECT 	
dwh_inventory.switch.id as switchid,
COUNT(DISTINCT dwh_inventory.switch_port.id) AS 'UsedPorts'

FROM	dwh_inventory.switch_port
JOIN	dwh_inventory.switch
ON	dwh_inventory.switch_port.switchId = dwh_inventory.switch.id
AND	dwh_inventory.switch.npv = 0
AND	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.switch_port.id FROM dwh_inventory.switch_port WHERE dwh_inventory.switch_port.gbicType LIKE '%ICL%')
AND	dwh_inventory.switch_port.active = 1
AND	dwh_inventory.switch_port.status &lt;&gt; 'NOT_LICENSED'
AND	dwh_inventory.switch_port.name NOT LIKE '%vfc%'
AND	dwh_inventory.switch_port.id IN (SELECT dwh_inventory.port_connectivity.portId FROM dwh_inventory.port_connectivity)
GROUP BY dwh_inventory.switch.id

) c ON c.switchid=a.switchid


ORDER BY b.FreePorts  DESC LIMIT 5 
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Data Center"/><mdProjectedItem name="Switch"/><mdProjectedItem name="Vendor"/><mdProjectedItem name="Model"/><mdProjectedItem name="Serial Number"/><mdProjectedItem name="Firmware"/><mdProjectedItem name="Total Ports"/><mdProjectedItem name="Free Ports"/><mdProjectedItem name="Used Ports"/><mdProjectedItem name="% Free"/><mdProjectedItem name="F-Port Count"/><mdProjectedItem name="E-Port Count"/><mdProjectedItem name="OtherPortCount"/><mdProjectedItem name="Port OK"/><mdProjectedItem name="Port Error"/><mdProjectedItem name="In-Active"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Data Center"><expression>[SQL5].[Data Center]</expression></dataItem><dataItem name="Switch"><expression>[SQL5].[Switch]</expression></dataItem><dataItem name="Vendor"><expression>[SQL5].[Vendor]</expression></dataItem><dataItem name="Model"><expression>[SQL5].[Model]</expression></dataItem><dataItem name="Serial Number"><expression>[SQL5].[Serial Number]</expression></dataItem><dataItem name="Firmware"><expression>[SQL5].[Firmware]</expression></dataItem><dataItem name="Total Ports"><expression>[SQL5].[Total Ports]</expression></dataItem><dataItem name="Free Ports" aggregate="total"><expression>[SQL5].[Free Ports]</expression></dataItem><dataItem name="Used Ports"><expression>[SQL5].[Used Ports]</expression></dataItem><dataItem name="% Free"><expression>[SQL5].[% Free]</expression></dataItem><dataItem name="F-Port Count"><expression>[SQL5].[F-Port Count]</expression></dataItem><dataItem name="E-Port Count"><expression>[SQL5].[E-Port Count]</expression></dataItem><dataItem name="OtherPortCount"><expression>[SQL5].[OtherPortCount]</expression></dataItem><dataItem name="Port OK"><expression>[SQL5].[Port OK]</expression></dataItem><dataItem name="Port Error"><expression>[SQL5].[Port Error]</expression></dataItem><dataItem name="In-Active"><expression>[SQL5].[In-Active]</expression></dataItem></selection>
		</query><query name="Port Utilization Trending">
			<source>
				
			<sqlQuery name="SQL1" dataSource="dwh_ports" type="passThrough">
			<sqlText>
SELECT

COUNT(distinct dwh_ports.port_dimension.id) as 'Used Ports',
dwh_ports.date_dimension.fulldate as fulldate

FROM dwh_ports.ports_fact
JOIN dwh_ports.switch_dimension
ON   dwh_ports.switch_dimension.tk=dwh_ports.ports_fact.switchtk
JOIN dwh_ports.port_dimension
ON   dwh_ports.port_dimension.tk=dwh_ports.ports_fact.porttk
AND	dwh_ports.switch_dimension.npv = 0
AND	dwh_ports.port_dimension.id NOT IN (SELECT dwh_inventory.switch_port.id FROM dwh_inventory.switch_port WHERE dwh_inventory.switch_port.gbicType LIKE '%ICL%')
AND	dwh_ports.ports_fact.status='OK'
AND     dwh_ports.port_dimension.name NOT LIKE '%vfc%'
AND     dwh_ports.port_dimension.id IN (SELECT dwh_inventory.port_connectivity.portId FROM dwh_inventory.port_connectivity)
JOIN dwh_ports.date_dimension
ON   dwh_ports.date_dimension.tk=dwh_ports.ports_fact.datetk
AND  dwh_ports.date_dimension.repmonthorlatest=1
GROUP BY dwh_ports.date_dimension.fulldate 


</sqlText>
		<mdProjectedItems><mdProjectedItem name="Used Ports"/><mdProjectedItem name="fulldate"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Used Ports" aggregate="total"><expression>[SQL1].[Used Ports]</expression></dataItem><dataItem name="fulldate"><expression>[SQL1].[fulldate]</expression></dataItem></selection>
		</query><query name="All Port Errors">
			<source>
				
			<sqlQuery name="SQL6" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT
COUNT(DISTINCT dwh_inventory.switch_port.id) as 'Port Count',
dwh_inventory.switch_port.rawPortStatus as 'Port Status'

FROM dwh_inventory.switch_port
WHERE dwh_inventory.switch_port.rawPortStatus IS NOT NULL

GROUP BY dwh_inventory.switch_port.rawPortStatus</sqlText>
		<mdProjectedItems><mdProjectedItem name="Port Count"/><mdProjectedItem name="Port Status"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Port Count" aggregate="total"><expression>[SQL6].[Port Count]</expression></dataItem><dataItem name="Port Status"><expression>[SQL6].[Port Status]</expression></dataItem></selection>
		</query></queries></report>